Some reports are included by default in WorkplaceManagement, and available for viewing by users and administrators. If default field names are changed, these reports may need to be modified. The reports can also be removed entirely, and new reports can be added.
The reports can be modified in two different folders in a default installation. Directories within those folders will function as different headings in the report selecting pane.
Admin Reports: C:\Program Files (x86)\WorkplaceManagement 4\_engine\Admin Reports
User Reports: C:\Program Files (x86)\WorkplaceManagement 4\_engine\User Reports
The reports are .rpt files that can be opened in text editors such as Notepad and Notepad++. Report files follow a standard format with an SQL query on the first line of the file, with no line breaks, followed by styling (if necessary).
SELECT _Desks.deskname, _Floors.FloorName FROM _Employees RIGHT OUTER JOIN _Desks ON _Employees.Desk_id = _Desks.desk_id LEFT OUTER JOIN _Floors ON _Desks.floor_id = _Floors.floor_id WHERE (_Employees.Id IS NULL) ORDER BY _Desks.deskname
/* Column widths */
.col1 { width: auto }
.col2 { width: auto }
.col3 { width: auto }
Develop a web page with Mobirise